<? //include"cek_sesi.php"; ?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Laporan Catatan Pelatihan Perusahaan</title>
<style type="text/css"></style>
<link href="../lib/styles.css" rel="stylesheet" type="text/css">

</head>

<body>
<p>

  <? include"../koneksi/koneksi.php"; ?>
</p>
<table style="border-collapse: collapse;" width="1150" border="1" bordercolor="#cccccc" cellpadding="3" cellspacing="0" align="center">
  <tr>
    <td>

<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="18%"><div align="right"><img src="../gambar/logo_dic.gif" alt="logo" width="124" height="67" /></div></td>
        <td width="57%" class="texttitle02C"><div align="center" class="texttitle02E">
          <div align="left" class="texttitle02B">
            <div align="center">PT. PARDIC JAYA CHEMICALS</div>
          </div>
        </div></td>
        <td width="25%" class="texttitle02C"><div align="left"><img src="../gambar/logo.png" alt="logo" width="67" height="66" /></div></td>
      </tr>
      <tr>
        <td colspan="3"><hr color="#CCCCCC" size="1" /></td>
        </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr> 	  
        <td width="64%" height="35"><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="5%">&nbsp;</td>
            <td width="14%" class="texttitle1ungu"><div align="left"></div></td>
            <td width="2%"><div align="center"></div></td>
            <td width="49%"><div align="left"></div></td>
            <td width="30%"><span class="texttitle1ungu">Tangerang,</span> <? echo date('j F Y');?> </td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td class="texttitle1ungu"><div align="left">Perihal</div></td>
            <td><div align="center">:</div></td>
            <td><div align="left">Company Training Plann </div></td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td class="texttitle1ungu">Tahun</td>
            <td><div align="center">:</div></td>
            <td><?
echo"$tahun"; ?></td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td class="texttitle1ungu">&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td></td>
            <td colspan="4" height="10"></td>
          </tr>
          <tr>
            <td colspan="5">
			
              <table width="99%" border="1" align="center" style="border-collapse: collapse;" bordercolor="#cccccc">
                
                <tr bgcolor="#000080" class="textmenu4a">
                  <td width="2%" rowspan="2"><div align="center">No</div></td>
                  <td width="17%" rowspan="2"><div align="left">Jenis Pelatihan</div></td>
                  <td colspan="2" bgcolor="#333300"><div align="center">Peserta</div></td>
                  <td colspan="13" bgcolor="#003300"><div align="center">Bulan</div></td>
                  </tr>
                <tr bgcolor="#000080" class="textmenu4a">
                  <td width="5%" bgcolor="#333300"><div align="center">Plan</div></td>
                  <td width="5%" bgcolor="#333300"><div align="center">Aktual</div></td>
                  <td width="4%" bgcolor="#996600"><div align="center">Jan</div></td>
                  <td width="4%" bgcolor="#0066CC"><div align="center">Feb</div></td>
                  <td width="5%" bgcolor="#006633"><div align="center">Maret</div></td>
                  <td width="5%" bgcolor="#CC0099"><div align="center">April</div></td>
                  <td width="5%" bgcolor="#990000"><div align="center">Mei</div></td>
                  <td width="4%"><div align="center">Jun</div></td>
                  <td width="4%" bgcolor="#000000"><div align="center">Juli</div></td>
                  <td width="4%" bgcolor="#00FFFF"><div align="center">Augst</div></td>
                  <td width="4%" bgcolor="#9900FF"><div align="center">Sept</div></td>
                  <td width="5%" bgcolor="#FF0000"><div align="center">Okt</div></td>
                  <td width="5%" bgcolor="#333333"><div align="center">Nov</div></td>
      <td width="5%" bgcolor="#990000"><div align="center">Desc</div></td>
                <td width="17%" bgcolor="#CC9900"><div align="center">Instruktur</div></td>
                </tr>
                <tr class="texttitle">
  <?
 $limit=200;
 if(empty($halaman)){
 $offset=0;
 $halaman=1;}
 else{
 $offset=($halaman-1) * $limit; }
 
 $tampil=mysql_query("select * from karyawan k, training t, seksi s, detail_training dt,
 					materi m, jobdesc_kualifikasi jk
					where
					k.kd_seksi=s.kd_seksi and
					dt.nik=k.nik and t.no_training=dt.no_training and m.kd_materi=jk.kd_materi and jk.nodet_jobdesc=t.nodet_jobdesc
					and	year(t.tgl_training)='$tahun' and t.status_training='ok' group by t.no_training
					limit $offset,$limit");
 $no=0;
 while($ada=mysql_fetch_array($tampil))
 {
 	if($j==0){
	echo"<tr bgcolor=#eeedee>";
	$j++;}
	else{
	echo"<tr bgcolor='#ffffff'>";
	$j--;}
	$no++;
?> 
                  <td class="texttitle14"><div align="center"><? echo"$no"; ?></div></td>
                  <td class="texttitle14"><div align="left"><? echo"$ada[nm_training]"; ?></div>
      <div align="center"></div></td>
                  <td class="texttitle14"><div align="center"><? echo"$ada[quota_peserta]"; ?></div></td>
                  <td class="texttitle14"><div align="center">
                    <?
	$cek=mysql_query("select k.nik from detail_training dt, training t,karyawan k
				  where dt.no_training=t.no_training and k.nik=dt.nik and
				  t.no_training='$ada[no_training]'");
	//$cek_hit=mysql_fetch_array($cek);
	$cek_hit=mysql_num_rows($cek);
	{ echo"$cek_hit"; }			   
	?>
                  </div>                  </td>
                  <td class="texttitle14"><div align="center"><? include"bln_jan.php"; ?></div></td>
                  <td class="texttitle14"><div align="center"><? include"bln_feb.php"; ?></div></td>
                  <td class="texttitle14"><div align="center"><? include"bln_maret.php"; ?></div></td>
                  <td class="texttitle14"><div align="center"><? include"bln_april.php"; ?></div></td>
	              <td class="texttitle14"><div align="center"><? include"bln_mei.php"; ?></div></td>
	              <td class="texttitle14"><div align="center"><? include"bln_juni.php"; ?></div></td>
	              <td class="texttitle14"><div align="center"><? include"bln_juli.php"; ?></div></td>
	              <td class="texttitle14"><div align="center"><? include"bln_agustus.php"; ?>
	              </div></td>
	              <td class="texttitle14"><div align="center">
	                <? include"bln_sept.php"; ?>
	              </div></td>
	              <td class="texttitle14"><div align="center">
	                <? include"bln_oktb.php"; ?>
	              </div></td>
	              <td class="texttitle14">
        <div align="center">
          <? include"bln_nov.php"; ?>
        </div></td>

      <td valign="top" class="texttitle14">
	    <div align="center">
	      <? include"bln_desc.php"; ?>
	    </div></td>
                <td valign="top" class="texttitle14"><div align="center"><? include"nm_trainer.php";?></div></td>
                </tr>
<? } ?>                
              </table>
		  			  </td>
            </tr>
          <tr>
            <td colspan="5"></td>
            </tr>
          <tr>
            <td colspan="5"></td>
            </tr>
        </table>		</td>
        </tr>
    </table></td>
  </tr>
  <tr>
    <td>
<table width="99%" border="0" align="center" style="border-collapse: collapse;" bordercolor="#cccccc">   
<tr>
<?
$lihat2=mysql_query("select * from karyawan k, training t, seksi s, detail_training dt,
 					materi m, jobdesc_kualifikasi jk
					where
					k.kd_seksi=s.kd_seksi and
					dt.nik=k.nik and t.no_training=dt.no_training and m.kd_materi=jk.kd_materi and jk.nodet_jobdesc=t.nodet_jobdesc
					and	year(t.tgl_training)='$tahun' and t.status_training='ok' group by t.no_training");
$jumbaris=mysql_num_rows($lihat2);
?>
<td width="4%"><div align="left"><span class="texttitle14">&nbsp;Jumlah : <? echo"$jumbaris"; ?></span></div></td>
</tr>
</table>
	
	
	
	</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="92%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="31%">
          <div align="left" class="texttitle12"></div></td>
        <td width="36%"><div align="right" class="texttitle12">&nbsp;</div></td>
        <td width="33%">&nbsp;</td>
      </tr>
      <tr>
        <td class="texttitle12"><div align="left">APPROVED BY</div></td>
        <td class="texttitle12"><div align="left">CHECKED BY</div></td>
        <td class="texttitle12"><div align="left">PREPARED BY</div></td>
      </tr>
      <tr>
        <td><div align="left"></div></td>
        <td class="texttitle12"><div align="right" class="style14"></div></td>
        <td class="texttitle12">&nbsp;</td>
      </tr>
      <tr>
        <td height="29"><div align="left"></div></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
<?
$tampil2=mysql_query("select k.nm_karyawan from karyawan k,admin a
					where k.nik=a.nik and a.nik='$nomor_induk_karyawan'");
$hs2=mysql_fetch_array($tampil2);
{ ?> 	  
	  
        <td>(Eddy Murphi)<hr size="1" width="80%" align="left" /></td>
        <td>(Muh Hasan)<hr size="1" width="80%" align="left" /></td>
        <td>(<? echo"$hs2[nm_karyawan]"; ?>)<hr size="1" width="80%" align="left" /></td>
      </tr>
<? } ?>
      <tr>
        <td>DATE : </td>
        <td>DATE : </td>
        <td>DATE : </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>


</td>
  </tr>
</table>
</body>
</html>
